Logical errors in database SQL retrieval queries

SQL is often used to express questions imposed by users. It is well known that this process is not error-free in that it may result in syntactically or semantically incorrect SQL queries. This article is meant to probe deeper into SQL queries that are incorrect, due to delusion errors. A classification of natural language questions will be introduced. The purpose of this classification is two-fold. Firstly, it gives insight into possible errors and enables us to distinguish between types of errors. Secondly, it is a means of determining the influence of measures (for instance, SQL training) that can be taken to reduce the number of aforementioned errors. For discussion, several of these measures will be presented and related to the classification.Abbreviations RA Relational algebra - SQL structured query language     

线性规划模型的自动生成与求解

本文描述了《有色企业经济活动分析决策支持系统》模型库中线性规划模型的自动生成与求解系统的设计思想、方法及实现     

计算机网络安全体系的研究

首先,结合国内外同行的最新研究成果,我们将对网络系统中的不安全因素加以分析,并形式化地给出一个安全计算机网络系统的定义;然后将从理论上阐述一个基于OSI-RM体系的网络安全保护体系的模型,并讨论该安全保护体系在现有系统中的作用。     

预测控制算法的统一格式及其在电加热炉的应用

本文根据常用的两类预测控制算法推出一种新型预测控制算法。并将其应用于一双输入/双输出的力学持久机电加热炉的温度控制系统上,获得了满意的结果:控温精度为±1.5℃/300℃,且适用于非最小相位系统。     

基于混合遗传算法的树状注水管网拓扑优化

以投资最小为目标函数,以井间隶属关系的惟一性、连接注水井数量等限制为约束条件,建立了树状注水管网拓扑优化数学模型.根据模型特点,将优化问题分为分配层和几何层,分别采用遗传算法和非线性优化方法进行求解.并对遗传算法的操作过程进行了改进,调整了适应函数,采用随机多父辈适应函数值加权交叉和多种变异操作,结合了模拟退火算法,并给出了初温的确定方法,改进了选择复制操作,从而形成了混合遗传算法.该算法能够有效地提高收敛速度,避免早熟收敛.利用算例说明了该方法的有效性.     

Cover Picture: Toward Large‐Scale Alignment of Electrohydrodynamic Patterning of Thin Polymer Films (Adv. Funct. Mater. 15/2006)

By integrating lithography and self‐assembly via electrohydrodynamic instabilities, Russel and co‐workers are able to guide initially flat polymer films to evolve into periodic arrays of pillars over regions much greater in extent than their natural domain sizes, as detailed on p. 1992. Novel structures that involve a combination of linear ridges and pillars are also produced, mainly as as result of the dynamic merging among preformed pillars. To pattern thin polymer films via electrohydrodynamic instabilities, we design and utilize two different kinds of mask patterns to guide pillars into alignment over regions much greater in extent than their natural domain sizes. First, narrow protruding ridges that intersect to form regular patterns on the mask trigger the growth of pillars beneath. Later, square and triangular packings of pillars develop in the regions enclosed by those ridges, preserving the registry from one domain to the next over a much larger area than within individual domains in unpatterned portions of the mask. Second, small square protrusions that are prealigned into a large regular array on the mask guide the formation of square packings of pillars in domains that conform to the mask, forming a large array of pillars. Novel structures involving a combination of linear ridges and pillars are also produced mainly due to the dynamic merging among preformed pillars. Finally, we find vertex symmetry of the mask pattern is necessary for generating and preserving ordered patterns on the polymer film.     

Important features of Iris OSQL

OSQL is the object-oriented database language developed for the Iris object-oriented database management system at Hewlett-Packard Laboratories. Its three fundamental constructs are objects, types, and functions. This paper provides an overview of the underlying concepts and some important features of OSQL.     

金坑水库浆砌石拱坝变形成因分析

根据金坑拱坝近20a时间的变形监测资料，通过拱坝变形的时间变化规律、空间分布规律、统计模型分析以及三维有限元变形仿真分析，对大坝安全性态作出评价。结果表明，大坝变形性态总体正常，但右坝段的一测点时效位移有向上游位移的趋势，应加强观测，同时也为今后大坝安全运行和管理提供了依据。     

A Silicon–Silica Nanocomposite Material

The synthesis and characterization of a novel silicon–silica nanocomposite material are reported. A self‐assembly method allows the encapsulation of silicon nanoclusters within the channels of a periodic mesoporous silica thin film. The result is the formation of a silicon–silica nanocomposite film with bright, room‐temperature photoluminescence in the visible range, and a nanosecond luminescence lifetime. The properties of the nanocomposite material have been studied by several analytical techniques, which collectively show the existence within the channels of non‐diamondoid‐structure‐type silicon nanoclusters with various hydrogenated silicon sites. It is estimated that the silicon nanoclusters in the silica mesoporous films occupy up to 39 % of the accessible pore volume. The nanocomposite film shows improved resistance to air oxidation compared to crystalline silicon. The high loading and chemical stability to oxidation under ambient conditions are important advantages in terms of the development of silicon‐based light‐emitting diodes from this class of materials.